Author: Halfvares Mats, Teknikhuset AB.

Published: 2004-09-21

Applies to:
  • Content Studio all versions

Type: Information


Symptoms

During the installation when the Content Studio site database is installed the following message will be displayed under certain circumstances. After this message the installation continues.
 
"CS Database installer could not verify the identity of the supplied run-time account. No SQL Server security has been applied. This has to be made manually later."

Cause

Content Studio did supply SQL-server with the name of the NT login that acts as runtime. This account must have login permissions in SQL Server in order to be allowed to use the databases. In this case SQL server does not recognize the supplied account name and thus cannot create the SQL server login for this account. In most cases this is a consequese of the SQL-server machine not beeing a member of the same (trusted) domain or active directory.

Resolution

An administrator must create a local Windows account on the SQL-server with the same login name (samAccountName) and password as the Content Studio runtime account. Add this account as a login in SQL-server and let the account be a member of the DB_OWNER role in each one of the following databases.
 
  • Content Studio
  • CSDS
  • Any database whose name starts with CSDS_
  • Any Content Studio site database

 

Status

This behaviour is by design. It strongly recommended, if possible, to install the SQL server on the same domain as the web server.